package com.cci.kangdao.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

import java.util.List;
import java.util.Map;

/**
 * @author William Du
 * @date 2019/8/19
 */
@MapperScan
public interface WorkOrderReasonDao {

    @Select("select * from WorkOrderReason_T where Type = #{type} and Flag = 0")
    List<Map<String,Object>> getWorkOrderReason(@Param("type") Integer type);

    @Select("select * from WorkOrderReason_T where ReasonKey = #{reasonKey} and Flag = 0")
    Map<String,Object> getWorkOrderReasonByReasonKey(@Param("reasonKey") Integer reasonKey);
}
